﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="Tags.aspx.vb" Inherits="prototype.Tags" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">
        .style1
        {
            font-family: "Segoe UI";
            font-weight: bold;
            font-size: medium;
            color: #333333;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <p>
        &nbsp;</p><center>
    <p class="style1">
        
        &nbsp;RESULT OF THE QUERY!</p></center>
        <center>
    <p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" 
            CellPadding="3" DataSourceID="SqlDataSource1" Width="395px" Height="185px" 
            style="font-size: small; margin-left: 0px; margin-bottom: 106px">
            <Columns>
                <asp:BoundField DataField="FirstName" HeaderText="Name" 
                    SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="Last Name" 
                    SortExpression="LastName" />
                <asp:BoundField DataField="Town" HeaderText="Town" SortExpression="Town" />
                <asp:BoundField DataField="Practice" HeaderText="Practice" 
                    SortExpression="Practice" />
                <asp:BoundField DataField="Telephone" HeaderText="Telephone" 
                    SortExpression="Telephone" />
                <asp:BoundField DataField="Address" HeaderText="Address" 
                    SortExpression="Address" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="Crime" HeaderText="Crime" SortExpression="Crime" />
                <asp:BoundField DataField="CompanyCommercial" HeaderText="Commercial" 
                    SortExpression="CompanyCommercial" />
                <asp:BoundField DataField="Conveyancing" HeaderText="Conveyancing" 
                    SortExpression="Conveyancing" />
                <asp:BoundField DataField="CivilLitigationPersonalInjury" HeaderText="Civil" 
                    SortExpression="CivilLitigationPersonalInjury" />
                <asp:BoundField DataField="Family" HeaderText="Family" 
                    SortExpression="Family" />
                <asp:BoundField DataField="WillsTrustsProbate" HeaderText="Wills &amp; Trusts" 
                    SortExpression="WillsTrustsProbate" />
                <asp:BoundField DataField="Employment" HeaderText="Employment" 
                    SortExpression="Employment" />
            </Columns>
            <FooterStyle BackColor="White" ForeColor="#000066" />
            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
            <RowStyle ForeColor="#000066" />
            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#F1F1F1" />
            <SortedAscendingHeaderStyle BackColor="#007DBB" />
            <SortedDescendingCellStyle BackColor="#CAC9C9" />
            <SortedDescendingHeaderStyle BackColor="#00547E" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:PlayersConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:PlayersConnectionString.ProviderName %>" 
            SelectCommand="SELECT * FROM [LawyersDetailsView2] WHERE ([Tag] = ?)">
            <SelectParameters>
                <asp:QueryStringParameter Name="Tag" QueryStringField="Tag" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
</p></center>
    <p>
        &nbsp;
        <br />
    </p>
    <p>
        <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/LawyersTags.aspx">Search more by Tags</asp:HyperLink>
    </p>
</asp:Content>
